/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50712
 Source Host           : localhost
 Source Database       : shouplus

 Target Server Type    : MySQL
 Target Server Version : 50712
 File Encoding         : utf-8

 Date: 10/08/2016 14:42:21 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_dic_node`
-- ----------------------------
DROP TABLE IF EXISTS `t_dic_node`;
CREATE TABLE `t_dic_node` (
  `id` varchar(32) NOT NULL,
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `removed` varchar(1) DEFAULT '0',
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `code` varchar(765) DEFAULT NULL,
  `desp` varchar(765) DEFAULT NULL,
  `name` varchar(765) DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  `parentId` varchar(32) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `FK_ooq6gvisatxwpmaqu0hqgtr7w` (`parentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_dic_node`
-- ----------------------------
BEGIN;
INSERT INTO `t_dic_node` VALUES ('1', '2016-03-11 00:08:10', '2016-08-01 12:15:24', '0', '1', '1', 'TOP', null, '顶级NODE', '0', null), ('2', '2016-03-11 00:08:57', '2016-03-13 11:30:46', '0', '1', '1', 'VISIBILITY', null, '可见性', '0', '1'), ('3', '2016-03-11 00:10:30', '2016-08-01 12:15:28', '0', '1', '1', '0', null, '可见', '0', '2'), ('4', '2016-03-11 00:11:11', '2016-08-01 12:15:31', '0', '1', '1', '1', null, '隐藏', '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `t_file_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_file_info`;
CREATE TABLE `t_file_info` (
  `id` varchar(32) DEFAULT NULL,
  `removed` varchar(1) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `originalFileName` varchar(255) DEFAULT NULL,
  `fileName` varchar(255) DEFAULT NULL,
  `contentType` varchar(255) DEFAULT NULL,
  `md5` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_file_info`
-- ----------------------------
BEGIN;
INSERT INTO `t_file_info` VALUES ('1', '0', '2016-10-05 09:59:12', 'xf', '2016-10-05 09:59:20', 'xf', 'd://1.jpg', '测试图片', 'PIC_PROMOTION', '12345667');
COMMIT;

-- ----------------------------
--  Table structure for `t_organ`
-- ----------------------------
DROP TABLE IF EXISTS `t_organ`;
CREATE TABLE `t_organ` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '机构名称',
  `px` int(11) DEFAULT NULL,
  `parentId` varchar(32) DEFAULT NULL COMMENT '父机构ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_organ`
-- ----------------------------
BEGIN;
INSERT INTO `t_organ` VALUES ('03d947f72c2449099fb1fcac9d0e6d1d', '0', '2016-03-13 01:05:40', '2016-03-13 01:05:40', '1', '1', '销售二部', '2', '96f2af1ebed5490e8415f1020465eb8c'), ('1156100ed08c48b6a9d9cfd35249f296', '0', '2016-03-13 01:04:21', '2016-03-13 01:04:53', '1', '1', '售后部', '3', null), ('387e80a8a89343ec9d615263f4e0e83f', '0', '2016-03-13 01:05:28', '2016-03-13 01:05:28', '1', '1', '销售一部', '1', '96f2af1ebed5490e8415f1020465eb8c'), ('3f0cc73880bd47d1a36b1390b4bb4c30', '1', '2016-08-01 12:47:31', '2016-08-01 12:47:31', '1', '1', '1', '1', 'f0a13720b9ca436b9d9891a7c136d3e7'), ('664210c800f14cc68ce0644d445e1f29', '0', '2016-10-04 15:19:02', '2016-10-04 15:19:02', '1', '1', '售后一部', '1', '1156100ed08c48b6a9d9cfd35249f296'), ('74a84b120e6040748f70ea0eb9fd813e', '0', '2016-03-13 01:05:55', '2016-03-13 01:05:55', '1', '1', '财务一部', '1', 'a8136c02335d4aefba5dd0db4bbf4118'), ('96f2af1ebed5490e8415f1020465eb8c', '0', '2016-03-13 01:02:53', '2016-03-13 01:02:53', '1', '1', '销售部', '1', null), ('a8136c02335d4aefba5dd0db4bbf4118', '0', '2016-03-13 01:03:58', '2016-03-13 01:03:58', '1', '1', '财务部', '2', null), ('f0a13720b9ca436b9d9891a7c136d3e7', '1', '2016-08-01 12:47:24', '2016-08-01 12:47:44', '1', '1', '机构测试11', '2', null), ('facd8fa46e0c43018e1dfab3467827ce', '0', '2016-03-13 01:06:07', '2016-03-13 01:06:07', '1', '1', '财务二部', '2', 'a8136c02335d4aefba5dd0db4bbf4118');
COMMIT;

-- ----------------------------
--  Table structure for `t_resource`
-- ----------------------------
DROP TABLE IF EXISTS `t_resource`;
CREATE TABLE `t_resource` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0:正常，1:删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `url` varchar(255) DEFAULT NULL COMMENT 'url',
  `code` varchar(255) DEFAULT NULL COMMENT 'code,权限code',
  `icon` varchar(255) DEFAULT NULL COMMENT '菜单图标',
  `visibility` varchar(255) DEFAULT '0' COMMENT '可见性，0可见，1不可见',
  `px` int(11) DEFAULT NULL COMMENT '排序',
  `parentId` varchar(32) DEFAULT NULL COMMENT '父ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_resource`
-- ----------------------------
BEGIN;
INSERT INTO `t_resource` VALUES ('dic', '0', '2016-08-01 12:37:38', '2016-08-01 12:37:41', '1', '1', '字典管理', '/manage/dic/', 'dic', null, '0', '1', 'system'), ('dic:add', '0', '2016-08-01 12:39:03', '2016-08-01 12:39:07', '1', '1', '字典新增', '/manage/dic/add/', 'dic:add', null, '1', '1', 'dic'), ('dic:edit', '0', '2016-08-01 12:41:16', '2016-08-01 12:41:23', '1', '1', '字典编辑', '/manage/dic/edit/', 'dic:edit', null, '1', '1', 'dic'), ('dic:remove', '0', '2016-08-01 12:41:05', '2016-08-01 12:41:34', '1', '1', '字典删除', '/manage/dic/remove/', 'dic:remove', null, '1', '1', 'dic'), ('organ', '0', '2016-02-27 13:47:37', '2016-03-13 00:59:35', '1', '1', '机构管理', '/manage/organ/', 'organ', null, '0', '1', 'system'), ('organ:add', '0', '2016-08-01 10:34:05', '2016-08-01 10:34:08', '1', '1', '机构新增', '/manage/organ/add/', 'organ:add', null, '1', '1', 'organ'), ('organ:edit', '0', '2016-03-13 01:00:42', '2016-03-13 01:02:00', '1', '1', '机构编辑', '/manage/organ/edit/', 'organ:edit', null, '1', '2', 'organ'), ('organ:remove', '0', '2016-03-13 01:01:20', '2016-03-13 01:02:05', '1', '1', '机构删除', '/manage/organ/remove/', 'organ:remove', null, '1', '3', 'organ'), ('resource', '0', '2016-02-27 13:47:56', '2016-03-11 10:56:06', '1', '1', '资源管理', '/manage/resource/', 'resource', null, '0', '2', 'system'), ('resource:add', '0', '2016-08-01 10:36:12', '2016-08-01 10:36:16', '1', '1', '资源新增', '/manage/resource/add/', 'resource:add', null, '1', '1', 'resource'), ('resource:delete', '0', '2016-03-12 23:36:01', '2016-03-12 23:36:01', '1', '1', '资源删除', '/manage/resource/delete/', 'resource:delete', null, '1', '3', 'resource'), ('resource:edit', '0', '2016-03-12 23:35:06', '2016-03-12 23:36:14', '1', '1', '资源编辑', '/manage/resource/edit/', 'resource:edit', null, '1', '2', 'resource'), ('role', '0', '2016-02-27 13:48:14', '2016-03-13 10:35:20', '1', '1', '角色管理', '/manage/role/', 'role', null, '0', '3', 'system'), ('role:add', '0', '2016-03-12 23:37:01', '2016-03-12 23:37:01', '1', '1', '角色新增', '/manage/role/add/', 'role:add', null, '1', '1', 'role'), ('role:delete', '0', '2016-08-01 10:38:28', '2016-08-01 10:38:31', '1', '1', '角色删除', '/manage/role/delete/', 'role:delete', null, '1', '1', 'role'), ('role:edit', '0', '2016-03-12 23:37:34', '2016-03-12 23:37:34', '1', '1', '角色编辑', '/manage/role/edit/', 'role:edit', null, '1', '2', 'role'), ('system', '0', '2016-02-25 21:06:30', '2016-03-11 14:28:19', '1', '1', '系统管理', null, 'system', null, '0', '1', null), ('user', '0', '2016-02-27 13:46:52', '2016-03-13 10:35:27', '1', '1', '用户管理', '/manage/user/', 'user', null, '0', '4', 'system'), ('user:add', '0', '2016-08-01 12:29:31', '2016-08-01 12:29:35', '1', '1', '用户新增', '/manage/user/add/', 'user:add', null, '1', '1', 'user'), ('user:edit', '0', '2016-08-01 12:31:09', '2016-08-01 12:31:12', '1', '1', '用户编辑', '/manage/user/edit/', 'user:edit', null, '1', '1', 'user'), ('user:remove', '0', '2016-03-12 23:40:09', '2016-03-12 23:40:09', '1', '1', '用户删除', '/manage/user/remove/', 'user:remove', null, '1', '3', 'user');
COMMIT;

-- ----------------------------
--  Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0:正常,1:删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL COMMENT '角色代码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES ('1', '0', '2016-02-25 21:17:46', '2016-10-04 15:41:54', '1', '1', '创始人', 'CSR');
COMMIT;

-- ----------------------------
--  Table structure for `t_role_resource`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_resource`;
CREATE TABLE `t_role_resource` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0：正常，1删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `roleId` varchar(32) DEFAULT NULL,
  `resourceId` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_role_resource`
-- ----------------------------
BEGIN;
INSERT INTO `t_role_resource` VALUES ('17de579b08c14709bd08fd57263c5425', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'role'), ('3a4d7487b0c84e1bb51750a2409b2559', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'role:edit'), ('3c2ad5cfdaa44aac96c8b567bc8bd2cb', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'organ:remove'), ('46f2dbaf3fca49c2a1c4bd16b4f738ff', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'role:delete'), ('5c44dfb999924f3da13b408878be82c1', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'organ:add'), ('6dd245892351487cb808bfd416eaa7a0', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'dic:add'), ('97106ba37f2340f7a70e254394cacc5a', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'user:remove'), ('9ef406f9965a46e6bd9849b447f446ee', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'dic:edit'), ('a330d1041d2e4812badef2ba5cc53736', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'dic'), ('adc7e7eb5b074deda4286713a1668aef', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'resource:edit'), ('aebaa4dfe96649e6a3e0e036a9407e6d', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'organ'), ('bbc75814d17246569302562185caccdf', '0', '2016-10-04 15:41:54', '2016-10-04 15:41:54', '1', '1', '1', 'system'), ('c4d3f970b8084d7c8da329285930bf2a', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'role:add'), ('cd7dd8cee2ba48d6a80ea341a6e14409', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'resource'), ('d09857dccc4f43969c8a5d86f4fb748c', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'resource:delete'), ('d3c9acef4a3a4d479798cd946bf1ebdc', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'user'), ('d86a5fbf2b5e46e8867db8bf014c9b3a', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'organ:edit'), ('ebb639f027214a0c96a32a5b6187f825', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'resource:add'), ('f0b3a651b88749db833cfd631c89cebf', '0', '2016-10-04 15:41:55', '2016-10-04 15:41:55', '1', '1', '1', 'dic:remove');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_log`;
CREATE TABLE `t_sys_log` (
  `id` varchar(32) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `operation` longtext,
  `logType` varchar(255) DEFAULT NULL,
  `dataId` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_sys_log`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_log` VALUES ('921b9c18f6504eaba745b672c87c8837', '2016-04-16 20:15:32', null, null, 'webhook事件出现异常', 'PINGPLUS_WEBHOOKS_EXCEPTION', null), ('2d82bfe13ff74b6e87dde7451cbc76ed', '2016-04-16 20:20:51', null, null, 'webhook事件出现异常', 'PINGPLUS_WEBHOOKS_EXCEPTION', null), ('f9c6720ee62f418cabf8623f5cf3a911', '2016-04-16 20:24:53', null, null, 'webhook事件出现异常', 'PINGPLUS_WEBHOOKS_EXCEPTION', null), ('9baf6ecf973f4e60bfa966ea0b640ce3', '2016-04-23 13:03:32', null, null, 'webhook事件出现异常', 'PINGPLUS_WEBHOOKS_EXCEPTION', null), ('331ea59f6619494ea93c7a68e4de3efd', '2016-04-23 13:05:02', null, null, 'webhook事件出现异常', 'PINGPLUS_WEBHOOKS_EXCEPTION', null), ('efd30d3edb954d588013de33050c6b6f', '2016-04-23 13:06:55', null, null, '{\"amount\":1,\"amountRefunded\":0,\"amountSettle\":1,\"app\":\"app_Dqv5GGjf5S0CyPmz\",\"body\":\"测试\",\"channel\":\"alipay\",\"clientIp\":\"192.168.199.1\",\"created\":1461387997,\"credential\":{},\"currency\":\"cny\",\"extra\":{\"buyer_account\":\"13764814802\"},\"id\":\"ch_u5SSO85ijv9Sn1iHa9irf1W5\",\"livemode\":true,\"metadata\":{},\"object\":\"charge\",\"orderNo\":\"e26f6cceec504716a27a031102a777be\",\"paid\":true,\"refunded\":false,\"refunds\":{\"data\":[],\"hasMore\":false,\"object\":\"list\",\"uRL\":\"/v1/charges/ch_u5SSO85ijv9Sn1iHa9irf1W5/refunds\"},\"subject\":\"王五2016-04-23日营业额盘点\",\"timeExpire\":1461474397,\"timePaid\":1461388006,\"transactionNo\":\"2016042321001004170288990719\"}', 'PINGPLUS_WEBHOOKS_CHARGE_SUCCESS', null), ('a1aa7e4623ce446a9c00326cf8f68bb7', '2016-04-23 13:07:01', null, null, '{\"amount\":1,\"amountRefunded\":0,\"amountSettle\":1,\"app\":\"app_Dqv5GGjf5S0CyPmz\",\"body\":\"测\",\"channel\":\"alipay\",\"clientIp\":\"192.168.199.1\",\"created\":1461387883,\"credential\":{},\"currency\":\"cny\",\"extra\":{\"buyer_account\":\"13764814802\"},\"id\":\"ch_qvTOKCrjXHGKabD8GOCivrTK\",\"livemode\":true,\"metadata\":{},\"object\":\"charge\",\"orderNo\":\"8929aa3db36a4e51a6b57bf75cddef75\",\"paid\":true,\"refunded\":false,\"refunds\":{\"data\":[],\"hasMore\":false,\"object\":\"list\",\"uRL\":\"/v1/charges/ch_qvTOKCrjXHGKabD8GOCivrTK/refunds\"},\"subject\":\"李四2016-04-23日营业额盘点\",\"timeExpire\":1461474283,\"timePaid\":1461387892,\"transactionNo\":\"2016042321001004170200448506\"}', 'PINGPLUS_WEBHOOKS_CHARGE_SUCCESS', null), ('dcb243d665fe42769f5d81b86627ef24', '2016-04-23 13:28:11', null, null, '{\"amount\":2,\"amountRefunded\":0,\"amountSettle\":2,\"app\":\"app_Dqv5GGjf5S0CyPmz\",\"body\":\"测试\",\"channel\":\"alipay\",\"clientIp\":\"192.168.199.1\",\"created\":1461389253,\"credential\":{},\"currency\":\"cny\",\"extra\":{\"buyer_account\":\"13764814802\"},\"id\":\"ch_rXvrLOb1Gab5vnnTm958ajP8\",\"livemode\":true,\"metadata\":{},\"object\":\"charge\",\"orderNo\":\"058fde9dc2384e2e8f2157508a4eed39\",\"paid\":true,\"refunded\":false,\"refunds\":{\"data\":[],\"hasMore\":false,\"object\":\"list\",\"uRL\":\"/v1/charges/ch_rXvrLOb1Gab5vnnTm958ajP8/refunds\"},\"subject\":\"王五2016-04-16日营业额盘点\",\"timeExpire\":1461475653,\"timePaid\":1461389281,\"transactionNo\":\"2016042321001004170200535359\"}', 'PINGPLUS_WEBHOOKS_CHARGE_SUCCESS', null), ('0879c122fb8249d593876fd742d933d7', '2016-04-23 22:27:10', null, null, '{\"amount\":1,\"amountRefunded\":0,\"amountSettle\":1,\"app\":\"app_Dqv5GGjf5S0CyPmz\",\"body\":\"测\",\"channel\":\"alipay\",\"clientIp\":\"192.168.199.1\",\"created\":1461387883,\"credential\":{},\"currency\":\"cny\",\"extra\":{\"buyer_account\":\"13764814802\"},\"id\":\"ch_qvTOKCrjXHGKabD8GOCivrTK\",\"livemode\":true,\"metadata\":{},\"object\":\"charge\",\"orderNo\":\"8929aa3db36a4e51a6b57bf75cddef75\",\"paid\":true,\"refunded\":false,\"refunds\":{\"data\":[],\"hasMore\":false,\"object\":\"list\",\"uRL\":\"/v1/charges/ch_qvTOKCrjXHGKabD8GOCivrTK/refunds\"},\"subject\":\"李四2016-04-23日营业额盘点\",\"timeExpire\":1461474283,\"timePaid\":1461387892,\"transactionNo\":\"2016042321001004170200448506\"}', 'PINGPLUS_WEBHOOKS_CHARGE_SUCCESS', null), ('5902ed40913949e4b2ee209f5f322728', '2016-04-23 22:50:20', null, null, '{\"amount\":2,\"amountRefunded\":0,\"amountSettle\":2,\"app\":\"app_Dqv5GGjf5S0CyPmz\",\"body\":\"测试\",\"channel\":\"alipay\",\"clientIp\":\"192.168.199.1\",\"created\":1461389253,\"credential\":{},\"currency\":\"cny\",\"extra\":{\"buyer_account\":\"13764814802\"},\"id\":\"ch_rXvrLOb1Gab5vnnTm958ajP8\",\"livemode\":true,\"metadata\":{},\"object\":\"charge\",\"orderNo\":\"058fde9dc2384e2e8f2157508a4eed39\",\"paid\":true,\"refunded\":false,\"refunds\":{\"data\":[],\"hasMore\":false,\"object\":\"list\",\"uRL\":\"/v1/charges/ch_rXvrLOb1Gab5vnnTm958ajP8/refunds\"},\"subject\":\"王五2016-04-16日营业额盘点\",\"timeExpire\":1461475653,\"timePaid\":1461389281,\"transactionNo\":\"2016042321001004170200535359\"}', 'PINGPLUS_WEBHOOKS_CHARGE_SUCCESS', null);
COMMIT;

-- ----------------------------
--  Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0:正常,1:删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `salt` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `cellphone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1', '0', '2016-08-01 12:49:12', '2016-09-01 13:53:02', '1', '1', 'admin', '3a022f9b61e72fe3fb40ff5cb0a2f6ab6277d5d0ca0a84fd14cc8356693209d7', '123456', '创始人', 'crossyamxun@126.com', '150210151401'), ('27b9b5959e1e4ca88d8e223f8d7f0566', '1', '2016-08-01 23:17:09', '2016-08-01 23:17:09', '1', '1', '11', '66fdc43fed8227a3d303b75d68e29ffa4e94d2f865f8a3d1653def3584970b9e', '5cbcc4d0067549f89840f33f2fd650b0', '11', '11', '11');
COMMIT;

-- ----------------------------
--  Table structure for `t_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0:正常,1:删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `userId` varchar(32) DEFAULT NULL COMMENT '用户ID',
  `roleId` varchar(32) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES ('e2dbbad15f0e4c1aa57096b98de4979f', '0', '2016-09-01 13:53:02', '2016-09-01 13:53:02', '1', '1', '1', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
